<?php
$mysql_host = "localhost";
$mysql_database = "group09_zxq_db";
$mysql_user = "326270_group09";
$mysql_password = "APMproject1";

$con = mysql_connect($mysql_host, $mysql_user, $mysql_password);
mysql_select_db($mysql_database, $con);

$user_ID = $_GET["id"];

$sql = "select * from Location where user_ID = $user_ID order by date_time asc";

$res = mysql_query($sql);
$i=1;
?>
<table width="100%"><tr><td>#</td><td>Location ID</td><td>Time</td><td>Longitude</td><td>Latitude</td></tr>
<?
while($row = mysql_fetch_assoc($res)){
?><tr><td><?=$i++?></td>
	<td><?=$row["location_ID"]?></td>
	<td><?=$row["date_time"]?></td>
	<td><?=$row["longitude"]?></td>
	<td><?=$row["latitude"]?></td>
</tr><?}?>
</table>